/*
 Navicat MySQL Data Transfer

 Source Server         : 127.0.0.1
 Source Server Type    : MySQL
 Source Server Version : 80013
 Source Host           : 127.0.0.1
 Source Database       : gomesmart

 Target Server Type    : MySQL
 Target Server Version : 80013
 File Encoding         : utf-8

 Date: 05/27/2019 16:50:36 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `user`
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `uid` varchar(32) NOT NULL,
  `gome_id` varchar(32) DEFAULT NULL COMMENT '大账号用户id',
  `username` varchar(50) DEFAULT NULL,
  `telephone` varchar(45) DEFAULT NULL,
  `email` varchar(128) DEFAULT NULL,
  `card_no` varchar(255) DEFAULT NULL,
  `platform_id` int(2) DEFAULT NULL,
  `apikey` varchar(32) DEFAULT NULL,
  `birthday` varchar(32) DEFAULT NULL,
  `real_name` varchar(10) DEFAULT NULL,
  `sex` int(11) DEFAULT NULL COMMENT '0:男  1:女  2:保密',
  `province_id` int(11) DEFAULT NULL,
  `city_id` int(11) DEFAULT NULL,
  `district_id` int(11) DEFAULT NULL,
  `avatar_file_id` varchar(32) DEFAULT NULL,
  `note` varchar(100) DEFAULT NULL,
  `nickname` varchar(32) DEFAULT NULL,
  `last_login_time` varchar(20) DEFAULT NULL,
  `create_time` varchar(20) NOT NULL,
  `full_name` varchar(64) DEFAULT '全名',
  `education` varchar(20) DEFAULT NULL COMMENT '学历',
  `profession` varchar(20) DEFAULT NULL COMMENT '职业',
  `height` varchar(20) DEFAULT NULL COMMENT '身高',
  `passwd` varchar(32) DEFAULT NULL,
  `weight` varchar(32) DEFAULT NULL,
  `cid` varchar(64) DEFAULT NULL,
  `mobile_company` int(64) DEFAULT NULL,
  `app_id` varchar(32) DEFAULT NULL,
  PRIMARY KEY (`uid`),
  KEY `user_telephone` (`telephone`),
  KEY `user_gomeid` (`gome_id`) USING BTREE,
  KEY `user_email` (`email`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户数据表，使用云服务的最终用户，包括用户的基本信息，比如用户名、电话号码、邮箱等，平台ID来区分用户系统，每个平台之间';

-- ----------------------------
--  Records of `user`
-- ----------------------------
BEGIN;
INSERT INTO `user` VALUES ('03c535f9a73946478163b0c9704d83aa', '100049421256', null, '18380448311', null, null, '1', '9f5c88c92ba74ea1873e0a9acbfb8f7a', null, null, null, null, null, null, null, null, null, '2019-01-15T10:46:47', '2019-01-12T16:00:12', '全名', null, null, null, null, null, 'e2c5fc95dab219d6cda422a95cd4dc497106b1741346684078103c99e10c2a3c', '0', 'c13ab1933fee034f'), ('03c535f9a73946478163b0c9704d83xx', '100049421256', null, '18380448311', null, null, '1', '9f5c88c92ba74ea1873e0a9acbfb8f7a', null, null, null, null, null, null, null, null, null, '2019-01-15T10:46:47', '2019-01-12T16:00:12', '全名', null, null, null, null, null, 'e2c5fc95dab219d6cda422a95cd4dc497106b1741346684078103c99e10c2a3c', '0', 'c13ab1933fee034f'), ('086b07e0b1c7414e83c471e6e56ad1d9', null, null, '18380448311', null, null, '1', null, null, null, null, null, null, null, null, null, null, null, '2019-01-10T09:56:33', '全名', null, null, null, null, null, null, null, 'xj123lkjs080lkjl'), ('088ba20d70db4cbebdbfe8409e4c09a6', '', 'admin2sssssssss', '13658026934', 'ww2122222@qq.com', null, '1', 'c07394775d5649b09d13a88bc7d563df', null, null, null, null, null, null, null, null, 'ww22222', null, '2018-12-29T14:49:06', '全名', null, null, null, null, null, null, null, null), ('0ef6336cdc3d4b2c9d55775694edd26a', '100036417010', null, '18482193500', null, null, '1', '9ad88c45f2f749b7b0bcd682066a531d', null, null, null, null, null, null, null, null, 'nicky', '2018-08-30T13:41:20', '2018-07-30T13:41:20', '全名', null, null, null, null, null, '47e02837546322d9925fde84ae147b44', '1', 'c13ab1933fee034f'), ('0f4c0c23eb274a609922bab2176c1e93', '100037482487', null, '15818665039', null, null, '1', '8faa446c27944d12bb22b190363f254d', null, null, null, null, null, null, null, null, null, '2018-06-22T11:36:19', '2018-05-25T10:43:55', '全名', null, null, null, null, null, '0', '0', 'c13ab1933fee034f'), ('0feeb4abc36e4f0cb788e4f65635f060', '100049452093', null, '13272760568', null, null, '1', '79d0097ef175486b8c5b3935fab0da68', null, null, null, null, null, null, null, null, null, '2019-01-15T16:19:55', '2019-01-12T14:31:30', '全名', null, null, null, null, null, null, null, 'c13ab1933fee034f'), ('1070b46da99241079b7d46e680845de6', '100049072711', null, '13668171441', null, null, '1', '4873232877fe4a079a5e0c22d7be2713', null, null, null, null, null, null, null, null, null, null, '2018-11-09T10:13:28', '全名', null, null, null, null, null, null, null, 'c13ab1933fee034f'), ('1331dc67183c45a5bd4fd88f7a60dbe4', '100037563669', null, '13652397525', null, null, '1', '5619ca80dc824fabb8828e967307bc18', '2018-01-01', '哈哈', '0', '1', '1', '72', '5978fdb1b7454fa490ffe2445330f708', null, '大众化测试过程优化测试反馈紧张积极地段即为扣扣看到我ID我ID忘', '2019-04-15T12:26:39', '2018-03-13T21:58:04', '全名', '博士及以上', '白领/一般职员公务员/事业单位', '', null, '', '0', '1', 'c13ab1933fee034f'), ('1572a53bbc6043f8ad4dac5ea38da955', '100049471743', null, '13438801593', null, null, '1', '936f647732564065957ddac7eaa5c9ac', null, null, null, null, null, null, null, null, null, '2019-02-20T11:19:43', '2019-02-01T15:58:06', '全名', null, null, null, null, null, '5z76eRxKj6k6v3dHAnekrOyCW48w+Tz2q0QIvUNT8vBWCwe8/ojol/m6R2BulvrS', '3', 'c13ab1933fee034f'), ('19638f2c94474dbfb23c6cedad11cfc1', '100049448704', 'test15198237813', '15198237813', null, null, '1', 'aa8bef45ddb946d99838da29f8899138', null, null, null, null, null, null, null, null, null, null, '2019-01-09T21:00:19', '全名', null, null, null, null, null, null, null, 'c13ab1933fee034f'), ('1b317214b0534ae88b4dd9a21a55ff14', '100035900606', null, '13548185459', null, null, '1', '54887cc1c4394f6ba5760b9f802a7f87', null, null, null, null, null, null, null, null, null, '2018-11-07T14:39:25', '2018-11-05T15:13:48', '全名', null, null, null, null, null, '0', '1', 'c13ab1933fee034f'), ('1c07e9deebb444f9a65775972d8e317a', '100049056901', null, '18500536591', null, null, '1', '2f5b66bdd46942acb8cbc034495f54f9', null, null, null, null, null, null, null, null, null, null, '2018-08-28T16:37:23', '全名', null, null, null, null, null, null, null, 'c13ab1933fee034f'), ('1e81c102245f44cfb3e01d6f2eab0167', '100049276744', null, '18610240057', null, null, '1', '52c24be8b2c24ca3ad06098b8a462608', null, null, null, null, null, null, null, null, null, '2019-03-22T09:38:43', '2019-03-14T18:10:58', '全名', null, null, null, null, null, '9U86duPy0EaE1WT8lov8cuBldomhd1lQpule8DReisnZ9v7+lbXCh4zP9zp3f9NX', '3', 'c13ab1933fee034f'), ('1f3aeb9b6aaf4ccdac9e02bfe3739602', null, 'ww2222222', '13658026909', 'ww222222@qq.com', null, '1', 'f524aaaf2fdf44c79ca3ccf32b06adb5', null, null, null, null, null, null, null, null, 'ww22222', null, '2018-12-29T14:45:25', '全名', null, null, null, null, null, null, null, null), ('2088042e293648cc86ea3ec344b9bdcc', '100049062608', 'gm_13927337677', '13927337677', null, null, '1', '606458dd3a06437389db909a08ddfc2e', null, null, null, null, null, null, null, null, null, null, '2018-08-01T16:26:12', '全名', null, null, null, null, null, null, null, 'c13ab1933fee034f'), ('22dec07e191a497db6513ab4926961ae', '100049465209', 'gm_15502089731', '15502089731', null, null, '1', 'd5d565f4cf204cacbcfde395ed273583', null, null, null, null, null, null, null, null, null, '2019-01-15T14:32:54', '2019-01-15T14:04:53', '全名', null, null, null, null, null, '0', '1', 'c13ab1933fee034f'), ('22dfd92874054fc4924f6472fcecc100', '100036136588', null, '18258475402', null, null, '1', '266f85e07cd34f68b53efab9b8e61e4b', null, null, null, null, null, null, null, null, null, null, '2018-05-22T11:27:20', '全名', null, null, null, null, null, null, null, 'c13ab1933fee034f'), ('23a82987de5b4036900255e05fcb6f4a', null, 'testpasswd', '13599992313', 'testpasswd@qq.com', null, '1', '0e116dcec3824ded867cf8334856af45', null, null, null, null, null, null, null, null, 'testpasswd', null, '2018-12-29T15:23:21', '全名', null, null, null, 'b7293e01a355ea0feacbb0362d7e4584', null, null, null, null), ('2485c63cfe1c4edfab4ee2bcb9199f8d', '100049463804', null, '18182227691', null, null, '1', '2de691cc89914a2e8ac8ae64d08fbaf4', null, null, null, null, null, null, null, null, null, null, '2019-01-14T11:25:30', '全名', null, null, null, null, null, null, null, 'c13ab1933fee034f'), ('297face7e4664596bd6cd92af801a06a', null, 'test21', '', '421354258@qq.com', null, '1', 'bedd78fda86749ceaded3ecc756e39d2', null, null, null, null, null, null, null, null, 'yt', null, '2018-12-20T16:47:44', '全名', null, null, null, '8a1955a5c1112f7df3141ecf96e68b70', null, null, null, null), ('2a7eae9a7a56447ea570b562d274b645', null, 'admin2s', '13489078793', 'admin2s@qq.com', null, '1', '1227bc2f6ad54ea48bff75bd68955093', null, null, null, null, null, null, null, null, 'admin2s', null, '2018-12-29T13:42:59', '全名', null, null, null, null, null, null, null, null), ('2f9e2caaf03a47eb9c46eee149480076', null, 'testrealName', '13323456782', 'testrealName@qq.com', null, '1', '77898288aaa049babdd1d63b5e26cae2', null, null, null, null, null, null, null, null, 'testrealName', null, '2018-12-29T14:58:58', '全名', null, null, null, '0192023a7bbd73250516f069df18b500', null, null, null, null), ('2fe50837b1d5471ba4112e7b7eccba55', null, 'ww22222ss', '13398797654', 'ww22222ss@qc.om', null, '1', '34e43a428523435dac743e28d58db404', null, null, null, null, null, null, null, null, '123456789012347', null, '2018-12-29T14:56:40', '全名', null, null, null, null, null, null, null, null), ('31f0dc16f5544aaa910f9c5373e3eb5d', null, null, '123', null, null, '1', null, null, null, null, null, null, null, null, null, null, null, '2019-01-09T17:01:11', '全名', null, null, null, null, null, null, null, 'xj123lkjs080lkji'), ('3214f133aaf44853b285ceb371341623', null, 'dw111111', '13550244641', 'dw1@qq.com', null, '1', 'd6a2a57c09e74d98a470001cc6025e4a', null, null, null, null, null, null, null, null, '中国人世个大好', null, '2018-05-28T18:02:58', '全名', null, null, null, '614c95d7a9cc61c2525b9f3f19aa396b', null, null, null, 'c13ab1933fee034f'), ('326c15038a6b4d5295a935b0c7c92a63', null, 'david1', '13550244644', 'niubi@qq.com', null, '1', 'd94d051fd2304e18906310ed55626a0f', null, null, null, null, null, null, null, null, 'niubi', null, '2018-05-25T14:04:22', '全名', null, null, null, '55fc5b709962876903785fd64a6961e5', null, null, null, 'c13ab1933fee034f'), ('32b3ee4485514015b427ab7ba6ad71d9', null, 'uuuuuu', '13655590982', 'uuuuuu@qq.com', null, '1', '5187cfc734ec4b05b8947351446e83e1', null, null, null, null, null, null, null, null, 'uuuuuu', null, '2018-12-29T11:14:05', '全名', null, null, null, null, null, null, null, null), ('33fec419b46c40c3980f6e4233999bc2', '100049505231', null, '15108272847', null, null, '1', '1e4e6f1b68b047e690055a85940f5efd', null, null, null, null, null, null, null, null, null, '2019-03-08T16:28:25', '2019-03-08T16:28:25', '全名', null, null, null, null, null, '0', '0', 'c13ab1933fee034f'), ('3427fa8ba2c64499b838f319cda21bd7', null, 'adminwwwwww', '13655890984', 'adminwwwwww@qq.com', null, '1', '48f6faca1ea441219acfd29698eacb0a', null, null, null, null, null, null, null, null, '22222', null, '2018-12-29T13:39:52', '全名', null, null, null, null, null, null, null, null), ('3440f8f3dfd14df5a538739130d8e1bd', '100038235673', null, '17610557113', null, null, '1', '06f2b4dadfe448639029cf21d401da3b', null, null, null, null, null, null, null, null, null, '2018-06-14T20:03:12', '2018-04-19T14:35:05', '全名', null, null, null, null, null, '0fcc91c6014d6394bd749e89a3fd17ab', '1', 'c13ab1933fee034f'), ('37f9e62db3b84e9cb81a5e2740b105f5', '77872039748', null, '13085853398', null, null, '1', '55719cf944ab40b28615e9ae3e4557f4', null, null, null, null, null, null, null, null, null, '2019-02-21T15:54:45', '2019-02-21T15:49:55', '全名', null, null, null, null, null, '0', '0', 'cd456add678cefee'), ('3af8e90148af49aab6092ec75882e712', '100040138054', null, '13684046276', null, null, '1', '5990eb232ca3453a86eb478f4c72a138', null, null, null, null, null, null, null, null, null, '2019-01-18T19:59:27', '2018-06-07T14:31:11', '全名', null, null, null, null, null, '0', '0', 'c13ab1933fee034f'), ('3cd511aa5a564136900abd7044207824', '100049484203', null, null, null, null, '1', '6b9c91c85c6447ce9c51d1e709fb6367', null, null, null, null, null, null, null, null, null, '2019-01-25T16:58:21', '2019-01-24T10:14:16', '全名', null, null, null, null, null, '0', '0', 'c13ab1933fee034f'), ('4180151a00ac40c89c3b5111bfa3261d', '100037507929', null, '18312564030', null, null, '1', 'e0c170c082104d59b7c6089a9b4b81c9', null, null, null, null, null, null, 'x', null, null, '2018-06-22T11:32:42', '2018-04-23T14:51:03', '全名', null, null, null, null, null, '8d4e0204f6123e3ef436ec4daa38146819a50a1e7dbb1803bceb591fd10d718e', '0', 'c13ab1933fee034f'), ('422cbb6b98b940a9b786e9d98643e600', '100049052520', 'gm_15818678487', '15818678487', null, null, '1', 'eb25de8b77c2458c9c378488f363189d', null, null, null, null, null, null, null, null, null, '2018-08-08T16:52:57', '2018-08-02T20:02:13', '全名', null, null, null, null, null, '0', '0', 'c13ab1933fee034f'), ('443f8c5c80c545298aeca32ec398fc6d', '100049166537', null, '18682095431', null, null, '1', '84b25a2b9fef48278df2fafdd98f85b3', null, null, null, null, null, null, null, null, null, '2019-03-08T16:07:29', '2019-01-12T10:39:56', '全名', null, null, null, null, null, '0', '1', 'c13ab1933fee034f'), ('45e6724a38424640b4f315925f86aa78', null, 'test1233', '13589809987', 'w@qq.com', null, '1', '1cc1765a1c4d4960a1fe399c56eb326b', null, null, null, null, null, null, null, null, 'w', null, '2018-12-29T11:03:56', '全名', null, null, null, null, null, null, null, null), ('47f0a684e7ee4f3fa78df3e44b56cefb', '100049421258', null, '13169934827', null, null, '1', 'bd47a5e5065245fabfff2e54f5df5e09', null, null, null, null, null, null, null, null, null, '2019-05-24T17:16:54', '2019-01-04T17:02:30', '全名', null, null, null, null, null, '1094c32c8003cdc2349851e12d318d75589db9e47a487e87f1897b354e30af96', '0', 'c13ab1933fee034f'), ('4803e316fe604393a613879a2d894782', null, null, '12213', null, null, '1', null, null, null, null, null, null, null, null, null, null, null, '2019-01-09T18:46:53', '全名', null, null, null, null, null, null, null, '1212'), ('4850d88dee0d4850a71fb1ba72f9759b', '100049243836', 'gm_17313005607', '17313005607', null, null, '1', '1a779fc3656742e19c2ec49687bf49c4', null, null, null, null, null, null, null, null, null, null, '2018-11-09T16:33:03', '全名', null, null, null, null, null, null, null, 'c13ab1933fee034f'), ('4c2fdc5d1b134362ab9c075a04035695', null, 'aa222222', '13488889999', 'aa222222@q.com', null, '1', 'b1069b54f3f24fbeba5bee8bf38fa0c8', null, null, null, null, null, null, null, null, 'aa222222', null, '2018-12-29T13:44:47', '全名', null, null, null, null, null, null, null, null), ('4edbae339ca340e594e363e3ba63ebd7', '100049075109', 'gm_17710789929', '17710789929', null, null, '1', 'eca33b217d8a445b9dad510c52c29b15', null, null, null, null, null, null, null, null, null, '2019-01-07T18:22:13', '2018-09-03T15:01:30', '全名', null, null, null, null, null, '0', '1', 'c13ab1933fee034f'), ('531bf25a87264783883985f44c98a54a', '100037697098', null, '13798272056', null, null, '1', '2cd42f1c39694a73bfabf4e978d56550', null, null, null, null, null, null, null, null, null, '2018-09-13T17:32:40', '2018-08-14T17:59:57', '全名', null, null, null, null, null, null, null, 'c13ab1933fee034f'), ('538f573877e64dbeba0b7c3205db9fc2', '100038376402', null, '17721168527', null, null, '1', '8f2af4f889dc460689c2fd88423378b5', null, null, null, null, null, null, null, null, null, '2018-08-24T00:31:48', '2018-05-22T11:26:43', '全名', null, null, null, null, null, null, null, 'c13ab1933fee034f'), ('59732d9765814c48842723b5bca54016', '100049166516', null, '15110020376', null, null, '1', '150294e5f9754c0ab2df2a23fd76c057', null, null, null, null, null, null, null, null, null, null, '2018-12-04T16:00:30', '全名', null, null, null, null, null, null, null, 'c13ab1933fee034f'), ('598c97bcb14a4dfcbe0cfe035f9c5759', '100049463803', null, '16675335990', null, null, '1', '64865df1642a44d9a1f0b0f6b55a1490', null, null, null, null, null, null, null, null, null, '2019-01-17T16:11:23', '2019-01-14T11:14:58', '全名', null, null, null, null, null, '0', '0', 'c13ab1933fee034f'), ('5e14f5320bcd467196ac2b9ac60fad27', '100049264329', null, '15348187580', null, null, '1', '7705b8ffe8f34e24999c8f42303f6982', null, null, null, null, null, null, null, null, null, null, '2019-01-11T19:27:29', '全名', null, null, null, null, null, null, null, 'c13ab1933fee034f'), ('6064a7d6226d4db4a53b8f960c6d406d', '100037688595', null, '13560318270', null, null, '1', '090af5fccb7b49588b90b226502fafad', null, null, null, null, null, null, null, null, null, '2018-04-23T10:34:00', '2018-04-02T18:37:40', '全名', null, null, null, null, null, '0861634030977569300001048500CN01', '2', 'c13ab1933fee034f'), ('61c1b67eb20a4d6bbba77e2d721ac038', '100038539343', null, '17600225056', null, null, '1', '0db7e8b1c0c842589246e440f38ff0db', null, null, null, null, null, null, null, null, null, '2019-05-08T14:10:32', '2018-03-12T18:30:24', '全名', null, null, null, null, null, 'bb28eaa9484407bed4e176c3eac5d2d4', '1', 'c13ab1933fee034f'), ('6450bb07c9e04b05b80027646e330e36', '100049166519', null, '17711322030', null, null, '1', '31ee557cb01745e59e45d12855f76b72', null, null, null, null, null, null, null, null, null, null, '2019-01-16T19:25:31', '全名', null, null, null, null, null, null, null, 'c13ab1933fee034f'), ('678c5e681621400ca5f480b8ad671ff1', '100049180183', 'gm_15313153729', '15313153729', null, null, '1', 'a94cdd6bcb884ae78f7c632f00d152bb', null, null, null, null, null, null, null, null, null, '2019-05-08T14:38:09', '2018-10-19T14:10:45', '全名', null, null, null, null, null, '0867601024619923300001048500CN01', '2', 'c13ab1933fee034f'), ('6a9bf4b867a24551a2d91298db448dc4', null, 'ww2222222', '13658026909', 'ww222222@qq.com', null, '1', 'fa51afcfa1ba4781bc3a6ab1f4d89574', null, null, null, null, null, null, null, null, 'ww22222', null, '2018-12-29T14:45:42', '全名', null, null, null, null, null, null, null, null), ('6b12eff3162540dcb967b3a00961d434', '100049453324', null, '18628230836', null, null, '1', '8633172a69cd4baf9b07846f5ec430c3', null, null, null, null, null, null, null, null, null, '2019-01-14T21:46:40', '2019-01-14T21:44:26', '全名', null, null, null, null, null, null, null, 'c13ab1933fee034f'), ('6b6c0a426b724e54b12c449b01fe3f78', null, 'qx222222222', '13599992323', 'qx2222222@qq.com', null, '1', '0a7469383dd440d1b080536b70782e86', null, null, null, null, null, null, null, null, 'qx2222222', null, '2018-12-29T11:27:35', '全名', null, null, null, null, null, null, null, null), ('7062f96699574d42b0e1d1c96e98a097', '100037476082', null, '15112385330', null, null, '1', '024d2b08ae1540eb92ca9b4e79fa24c6', null, null, null, null, null, null, null, null, null, '2018-05-14T14:39:15', '2018-03-15T15:40:32', '全名', null, null, null, null, null, '0869158022358085300001048500CN01', '2', 'c13ab1933fee034f'), ('70e931f8a4094668baadf6a7183e7447', '100041258939', null, '13420994540', null, null, '1', 'b91d7d6197a648da89a2676714944b7f', null, null, null, null, null, null, null, null, null, '2019-01-31T20:44:06', '2018-11-05T11:00:46', '全名', null, null, null, null, null, '51fc0b45441f9d2d7412b578c259fbc29e3d22797218ff3e80c6e42322a2c5ce', '0', 'c13ab1933fee034f'), ('722291c69274482b9d098d3cd4c64dc8', '100049465207', 'gm_18682165710gzu', '18682165710', null, null, '1', '7fcf25d7d7fa4d8290b2571e23b7610f', null, null, null, null, null, null, null, null, null, '2019-01-15T12:09:09', '2019-01-15T12:08:28', '全名', null, null, null, null, null, '0', '0', 'c13ab1933fee034f'), ('726b214672af4086a6703e9d0fe363a9', '100037565582', null, '13006675018', null, null, '1', 'c333e372243e4214ac43d5480d71663f', null, null, null, null, null, null, null, null, null, '2019-05-22T18:54:33', '2018-09-18T11:34:32', '全名', null, null, null, null, null, '0', '0', 'c13ab1933fee034f'), ('7309cea8f4de4eb9a3c1026de3e2a62f', null, 'uuuuuu', '13655590982', 'uuuuuu@qq.com', null, '1', '6ac2b5898e384af0b84507ea47305b3b', null, null, null, null, null, null, null, null, 'uuuuuu', null, '2018-12-29T11:14:04', '全名', null, null, null, null, null, null, null, null), ('7350d374ecdc43e48dfd535636039d57', null, null, '18380448311', null, null, '1', null, null, null, null, null, null, null, null, null, null, null, '2019-01-09T18:51:45', '全名', null, null, null, null, null, null, null, '1212'), ('75cce2e5962443939923597b90bbdd56', '100049480627', null, null, null, null, '1', '56740d54e37b42f084f820ab4fa6643a', null, null, null, null, null, null, null, null, null, '2019-02-28T14:54:34', '2019-01-23T13:46:23', '全名', null, null, null, null, null, '0', '0', 'c13ab1933fee034f'), ('76c735bce3ab462d806d369f4811c9f7', '100036145564', null, '18380448311', null, null, '1', 'b9ca06f7be204d80a0d679f597bf17cf', null, null, null, null, null, null, null, null, null, '2018-09-18T14:45:33', '2018-06-25T15:44:56', '全名', null, null, null, null, null, '0', '1', 'c13ab1933fee034f'), ('78935badaa2b4619a989f1fe62352243', '100049453328', null, '13368105541', null, null, '1', '6a74923c9715489c85b14d2b40a2337a', null, null, null, null, null, null, null, null, 'string', '2019-05-06T16:06:25', '2019-01-11T21:27:08', '全名', null, null, null, null, null, '0', '0', 'c13ab1933fee034f'), ('797f6c6f5c5540709d75fabb510a4f68', null, null, '18676725760', null, null, '1', null, null, null, null, null, null, null, null, null, null, null, '2019-01-09T17:31:37', '全名', null, null, null, null, null, '0', null, 'xj123lkjs080lkjl'), ('7a796d5128be49b3b1fffbb800e1f926', '100049463805', null, '15928804272', null, null, '1', '113e6b60e86448dc94cd62eb8a498f33', null, null, null, null, null, null, null, null, null, '2019-01-14T16:22:16', '2019-01-14T11:39:15', '全名', null, null, null, null, null, null, null, 'c13ab1933fee034f'), ('7af3bee4307d4c118384b4932db280cf', null, 'admin11', '13488889999', 'aa222222@q.com', null, '1', '88991f643a5143fbbc921f47e6ee3f6c', null, null, null, null, null, null, null, null, 'aa222222', null, '2018-12-29T13:57:11', '全名', null, null, null, null, null, null, null, null), ('7c3d49dc464746a8b6d64dc23ecbf219', '100049465237', 'gm_18581885158', '18581885158', null, null, '1', '57d3b7d010a94a54893b5096144a74f9', null, null, null, null, null, null, null, null, null, '2019-01-17T14:09:10', '2019-01-16T11:10:13', '全名', null, null, null, null, null, null, null, 'c13ab1933fee034f'), ('7cba32eb251748d2a24e1821f79b09ba', null, '111111', '13544444441', '1010118728@qq.com', null, '1', '441ed9b86ba54831a3373305ea22cad8', null, null, null, null, null, null, null, null, 'duwei', null, '2018-05-31T16:05:24', '全名', null, null, null, '7fa8282ad93047a4d6fe6111c93b308a', null, null, null, 'c13ab1933fee034f'), ('7d103b405d0e4ab8b99972de0958bbdb', '100038315349', null, '13430686048', null, null, '1', '7c468dfc223f4770be267975bac2db2e', null, null, null, null, null, null, null, null, null, '2018-08-06T18:09:12', '2018-08-02T16:54:15', '全名', null, null, null, null, null, '0', '0', 'c13ab1933fee034f'), ('7de9396b00a74af2bee727a3e23cd7bc', null, '', '18312564030', null, null, '1', null, null, null, null, null, null, null, null, null, null, null, '2018-06-28T10:24:20', '全名', null, null, null, null, null, null, null, 'c13ab1933fee034f'), ('7e5b951ad3f94ab29f24c9173d44395e', null, 'ww22222', '13599992311', 'ww22222@qq.com', null, '1', '9d0332af55a2483684a761b8fddbfaa7', null, null, null, null, null, null, null, null, 'ww22222', null, '2018-12-29T11:27:33', '全名', null, null, null, null, null, null, null, null), ('7f4c4435cdb143d585f05020e8c4451b', '100049133579', null, '13699401024', null, null, '1', 'f3915c25519a47d2a6e451d33bb9105c', null, null, null, null, null, null, null, null, null, '2019-04-23T09:52:49', '2019-03-11T10:32:39', '全名', null, null, null, null, null, 'H0B5pT69EJxUrIxMQEyKp959eOcQAvL0VEVxIZNTgfiuYdDv9yI1aArlNnzQn+CQ', '3', 'c13ab1933fee034f'), ('8483b60dedde4e7a9076874532a069ef', null, 'admin1', '13689872234', 'wq@qq.com', null, '1', '8ac99c822ad54de6bf4f61afa49a300f', null, null, null, null, null, null, null, null, '1', null, '2018-12-29T11:05:32', '全名', null, null, null, null, null, null, null, null), ('8629efd648d04c9fb69ad257ad3f2f83', null, 'admin2222', '13590902389', 'admin2222@qq.com', null, '1', '58e5b5fa7ac24974b6d1fd3a868b0906', null, null, null, null, null, null, null, null, 'admin2222', null, '2018-12-29T11:35:05', '全名', null, null, null, null, null, null, null, null), ('894b924aec7047fc8322471561ce6e5c', null, 'admin2222e', '13698990932', 'vadmin2222e@qq.com', null, '1', '077ba14859ff464f901e1699b2e9e0a1', null, null, null, null, null, null, null, null, 'qzs', null, '2018-12-29T13:39:05', '全名', null, null, null, null, null, null, null, null), ('935b4d72edf94d12954674329d572eb3', '74152379476', null, null, null, null, '1', '7704270f50244d68a00a37a9933f676a', null, null, null, null, null, null, null, null, null, '2019-02-25T13:53:01', '2017-10-25T21:56:04', '全名', null, null, null, null, null, '9fa48739dc9ead3941348f3f045001f7b241c92d965b7227cd90dde7be344639', '0', 'cd456add678cefee'), ('98164c6d09ee44c7994b450815df6a3a', null, 'wwaaaaaaaaa', '13589802311', 'wwaaaaaaaaa@qq.com', null, '1', 'b95610c22bf74c6c8db68a819f383626', null, null, null, null, null, null, null, null, 'wwaaaaaaaaa', null, '2018-12-29T14:55:21', '全名', null, null, null, null, null, null, null, null), ('98415add48da4160a084a3cfee7fdeee', '100049453333', null, '15310694731', null, null, '1', 'dc1253e62d4b40df88c6fb975d3fae1b', null, null, null, null, null, null, null, null, null, null, '2019-01-11T21:28:32', '全名', null, null, null, null, null, null, null, 'c13ab1933fee034f'), ('9b63ff8bb6d54f0c9b531f34a84293ed', null, '2saaaa', '13658998893', '2saaaa@qq.com', null, '1', 'dfb98a5d7f7c42738a4f37bac26cee8b', null, null, null, null, null, null, null, null, '2saaaa', null, '2018-12-29T14:14:41', '全名', null, null, null, null, null, null, null, null), ('a057a5a70970473787c9c832a22fd6f0', null, '123456', '13544444444', 'dw@123456.com', null, '1', 'c9eb0bafe2ac453ab8272d1b3d532b20', null, null, null, null, null, null, null, null, 'duwei', null, '2018-05-28T18:25:18', '全名', null, null, null, '614c95d7a9cc61c2525b9f3f19aa396b', null, null, null, 'c13ab1933fee034f'), ('a1db15163d6a4c868fec5547bb630a19', '100040166223', 'david12', '13550244643', 'dw@qq.com', null, '1', 'e6ce1f8521c04ea1807f6997252ef649', null, null, null, null, null, null, '7d3462dc6e12478a9b90ca25161c5ce9', null, 'duwei', '2019-05-05T11:14:22', '2018-05-28T15:17:08', '全名', null, null, null, '5ff84c7646419ffeb65cb5625de99723', null, '71dd901485d618fd3ba57b7ccaabdd01', '1', 'c13ab1933fee034f'), ('a4cf9fea2c2b464db1abefb39b698599', null, 'cloudworker1314', '18180932171', '', null, '1', '9cd44ff237eb4a48b8b505e4a497a4b9', null, null, null, null, null, null, null, null, 'liamogui', null, '2018-05-31T16:07:45', '全名', null, null, null, 'd4ae079a8a3bfbd9bce493b33fd91bc8', null, null, null, 'c13ab1933fee034f'), ('a6ae8173ebba4070b10d73eaf11ad5cd', '100041879331', null, '', null, null, '1', '22e51828af4e4a3ab1f37b7c2923ff8c', null, null, null, null, null, null, null, null, null, null, '2018-10-17T14:33:29', '全名', null, null, null, null, null, null, null, null), ('ad2bec175f2c4ed8a137080c5f5a46a0', null, 'testappid', '13489720976', 'testappid@qq.com', null, '1', '6966a187e5ec4a238f65145afa7acd0d', null, null, null, null, null, null, null, null, 'testappid', null, '2018-12-29T15:03:48', '全名', null, null, null, '85799dbcffaf5a358d487e06f0493731', null, null, null, null), ('ae4e7fa5451b4c82a7cbbb72ba78e845', '100049463813', 'gm_18628063349', '18628063349', null, null, '1', '45f060282e78427986a53569f520927a', null, null, null, null, null, null, null, null, null, '2019-01-14T18:18:36', '2019-01-14T16:29:54', '全名', null, null, null, null, null, null, null, 'c13ab1933fee034f'), ('b1679493ef0b4c919d53b9f6e686e335', null, 'admin1sds', '13499887772', '', null, '1', 'ed5c8a2f483b4eda905296f000519a3e', null, null, null, null, null, null, null, null, 'admin1sds', null, '2018-12-29T13:46:11', '全名', null, null, null, 'a510514962468e99aa1e9a80c4add5af', null, null, null, null), ('b1fc9a55c88e43cc9ca1cf0858eb031e', null, 'ww22224', '13658026924', '', null, '1', '16597d50142644c98474099b4ad943a4', null, null, null, null, null, null, null, null, 'ww222223', null, '2018-12-29T14:36:13', '全名', null, null, null, null, null, null, null, null), ('b21370d83d7a4456845fcb07a15965d4', null, null, '123', null, null, '1', null, null, null, null, null, null, null, null, null, null, null, '2019-01-09T16:52:50', '全名', null, null, null, null, null, null, null, ''), ('bb6f818e4cdd4d079d54edefb0e5c05a', '100047315103', 'gm_18160798693', '18160798693', null, null, '1', '12d5885ee62c49d292240a13ba5025e5', null, null, null, null, null, null, null, null, null, null, '2018-05-30T22:31:02', '全名', null, null, null, null, null, null, null, 'c13ab1933fee034f'), ('c14b243d56b94b8cb1bd75e9fe5200dd', '100037441122', null, '17603069655', null, null, '1', '2577166916994afc88279640e2360631', null, null, null, null, null, null, null, null, null, '2018-04-23T18:36:39', '2017-12-05T11:28:31', '全名', null, null, null, null, null, 'e52c76132deb48d8447c4a608f078c18', '1', 'c13ab1933fee034f'), ('c7d4bf75ff3c431a8c95e50d98b7df63', null, 'admin2222112', '13489857755', '', null, '1', 'df5dd08895744377a586ae8063972f27', null, null, null, null, null, null, null, null, 'admin2222212', null, '2018-12-29T11:36:10', '全名', null, null, null, null, null, null, null, null), ('c8604a27e8a841318a20ec24b94f769d', '100037690605', null, '18576040506', null, null, '1', 'd76f4672c8534956881bb428e51c219f', null, null, null, null, null, null, null, null, null, '2019-01-23T13:50:16', '2018-03-20T16:23:16', '全名', null, null, null, null, null, '0', '0', 'c13ab1933fee034f'), ('cb74c64a4c3542e196aa64547c1369e9', null, '', '18950416841', null, null, '1', null, '', '', '0', null, null, null, '3ad1bcbb93fd462a94edd0a9331015d2', null, '姐姐呢', '2019-05-23T15:14:07', '2018-06-21T17:38:11', '全名', null, null, null, null, null, '580694c06d884d53d98d86bf7ee8f35b52f327cad7e14745bf783faa0282b6a8', '0', 'c13ab1933fee034f'), ('cdd70c4b830e439a834da6268b60c330', '100037521924', null, '13556831518', null, null, '1', '62460d6782e04c8bb2e810fe5ddd20a6', null, null, null, null, null, null, null, null, null, null, '2018-06-11T10:43:29', '全名', null, null, null, null, null, null, null, 'c13ab1933fee034f'), ('d101739a2edf43aab432759b2a7a6308', '100049465201', 'gm_17869022586', '17869022586', null, null, '1', 'f460153de9c742ffac233b7f39cee34a', null, null, null, null, null, null, null, null, null, '2019-01-14T22:37:19', '2019-01-14T21:46:12', '全名', null, null, null, null, null, null, null, 'c13ab1933fee034f'), ('d2f2d106b3b84c15bb4bbfc65bfa53e8', '100038598877', null, '18211051910', null, null, '1', '09ef3cd8ff584e17a65474ac6042b804', null, null, null, null, null, null, null, null, null, '2018-03-26T13:54:44', '2018-03-26T13:54:43', '全名', null, null, null, null, null, '9b0c516be2f4f7855a68a81bef8ab8e4', '1', 'c13ab1933fee034f'), ('d412a80088c24888b0849c80649f4986', '100049505249', null, null, null, null, '1', 'ab8e90301bee493b92852ca864876479', null, null, null, null, null, null, null, null, null, '2019-02-15T15:47:01', '2019-02-13T21:23:00', '全名', null, null, null, null, null, '0', '3', 'c13ab1933fee034f'), ('d4408e7a3ea74d549a8be0df925cc8fc', '100037423609', null, '18950416841', null, null, '1', 'be7e16d8bf614e72bef9afcc02ee29fe', null, null, null, null, null, null, null, null, null, '2018-08-06T11:18:41', '2018-04-02T17:48:26', '全名', null, null, null, null, null, '0', '0', 'c13ab1933fee034f'), ('d67cf0c5207549afbbc5de4a05a85bdf', '100049062601', null, '15882479025', null, null, '1', '4140cb20f6014046bf43818577d2aa23', null, null, null, null, null, null, null, null, null, '2018-11-20T10:16:01', '2018-11-07T14:40:30', '全名', null, null, null, null, null, 'c14dd7ac324695dbdfa409ea7a562b22', '1', 'c13ab1933fee034f'), ('d9a5ad628e934d8fbc5c66d940c95102', null, 'aaaaaa', '13658026906', '333@qq.com', null, '1', 'a2e94a4f0e03413a9fa63fc263fd065d', null, null, null, null, null, null, null, null, 'aaaaaa', null, '2018-12-20T18:22:15', '全名', null, null, null, '552e6a97297c53e592208cf97fbb3b60', null, null, null, null), ('deeb41934b6a46fba50fe8e0c90e9f09', '100038884705', null, '13552338197', null, null, '1', '832c622f4c064973aeaa8d19ab59107e', null, null, null, null, null, null, null, null, null, '2019-01-07T18:23:35', '2018-11-12T15:03:30', '全名', null, null, null, null, null, '0', '1', 'c13ab1933fee034f'), ('defd8160e80743408a24877e4fff450f', null, 'admin22123', '13489887765', '111111@qq.com', null, '1', 'e03d60b0796f4487ad747e3d23b18ad7', null, null, null, null, null, null, null, null, 'admin22123', null, '2018-12-29T12:32:17', '全名', null, null, null, '9d18dfc50ba5f22bdd3a36f13a4ac77b', null, null, null, null), ('e4d9c4562ced45dbae2fd68d58dc699b', null, null, '17721168527', null, null, '1', null, null, null, null, null, null, null, null, null, null, null, '2018-08-24T11:54:00', '全名', null, null, null, null, null, null, null, 'b1sab1123fae034f'), ('e5215eef955841a99f3f4bfb470d5283', null, 'testpasswd', '13599992313', 'testpasswd@qq.com', null, '1', '145a21ef14dc4507a6c79f7ba17bf251', null, null, null, null, null, null, null, null, 'testpasswd', null, '2018-12-29T15:23:39', '全名', null, null, null, 'b7293e01a355ea0feacbb0362d7e4584', null, null, null, null), ('e7680e36bc1447269cc77b71c31c7211', '100049276732', null, '18676725760', null, null, '1', '19806bd7b92f4c46b88dc18afd50901d', null, null, null, null, null, null, null, null, null, '2019-01-11T17:03:54', '2018-11-28T10:34:08', '全名', null, null, null, null, null, '09fd24b315012149aa1b1f9f9c3c4f7ebec59c12478c7d041744a2aeee0e7397', '0', 'c13ab1933fee034f'), ('ed131f7cdea740d2a1015f481c5f9bb8', null, 'admin2222', '13590902389', 'admin2222@qq.com', null, '1', '6139b518de414a44b2fded2185f4d289', null, null, null, null, null, null, null, null, 'admin2222', null, '2018-12-29T11:35:00', '全名', null, null, null, null, null, null, null, null), ('ef59213d2cfa4ac186791beb63dfbe33', '100037688581', null, '13543342461', null, null, '1', '71c6c722671140959a8daeaed197f489', null, null, null, null, null, null, null, null, null, '2019-03-01T11:23:17', '2018-05-23T11:53:35', '全名', null, null, null, null, null, '0', '1', 'c13ab1933fee034f'), ('f0a652f7f7a04bff9a918fee2baa3610', null, 'adminw', '13659993121', '2@q.com', null, '1', 'd92cc117fcd64d7aa0ef7bf32f1481cc', null, null, null, null, null, null, null, null, 'a', null, '2018-12-29T13:41:15', '全名', null, null, null, null, null, null, null, null), ('f3e5ace967564c7a992cd0eacf69f43a', null, 'testtest', '13658026908', 'testtest@qq.com', null, '1', 'f4b3c783c033446abdc1ca7b4905ff93', null, null, null, null, null, null, null, null, 'testtest', null, '2018-12-29T14:50:59', '全名', null, null, null, null, null, null, null, null), ('f489ac5b94e4467085608b67f0cc8767', '100051093172', null, '18101035423', null, null, '1', 'b89543c536ac4734b30a3b64f10e59c4', null, null, null, null, null, null, null, null, null, '2019-05-22T17:48:25', '2019-05-22T17:48:23', '全名', null, null, null, null, null, '2dde790524ee080589def2328f7831c7', '1', 'c13ab1933fee034f'), ('fb0f8d32649543d7b289b99d29b46882', '100049057501', null, '18190976207', null, null, '1', '31794d2d5e4444c2825d792be2d101b9', null, null, null, null, null, null, null, null, null, '2019-04-18T15:31:12', '2018-11-22T14:11:35', '全名', null, null, null, null, null, '31f0b87c7f2336367cafedd763c9c532', '1', 'c13ab1933fee034f'), ('fe8a4f277a7c4178983751cbc8c463cc', '100038304261', null, '18280215128', null, null, '1', 'e6ea4b6a2f5c4e5b8f719b44146b69d3', null, null, null, null, null, null, null, null, null, null, '2018-11-13T11:40:00', '全名', null, null, null, null, null, null, null, 'c13ab1933fee034f'), ('ff8080815c5e9790015c6159976307e9', '100048628101', '美美', '18875018096', '', '', '1', '2f6a630d8fa911e78c84525400704926', '', '', null, null, null, null, '', '', '', '2018-11-06T16:38:14', '2017-06-01T09:51:20', '全名', '', '', '', '', '', '68ed30144fa316dd349aef400400f081', '1', 'c13ab1933fee034f'), ('ff8080815e0b6cec015e0e3767460250', '100049220526', 'gm_13658026904', '13658026904', null, null, '1', '606458dd3a06437389db909a08ddfc2e', null, null, null, null, null, null, null, null, 'ssssss', '2019-05-24T16:53:09', '2018-08-01T16:26:12', '全名', null, null, null, '', null, '32ae141e939af835e7f75817fdca35a6', '1', 'c13ab1933fee034f');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
